/*
 Navicat Premium Data Transfer

 Source Server         : 钢琴外网
 Source Server Type    : MySQL
 Source Server Version : 50637
 Source Host           : 101.132.173.254:3306
 Source Schema         : piano

 Target Server Type    : MySQL
 Target Server Version : 50637
 File Encoding         : 65001

 Date: 07/05/2018 14:00:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`) USING BTREE,
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE,
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('RenrenScheduler', 'MeterServer011522407299590', 1522573181380, 15000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务';

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `job_id` (`job_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务日志';

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key` varchar(50) DEFAULT NULL COMMENT 'key',
  `value` varchar(2000) DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `key` (`key`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置信息表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', 0, '云存储配置信息');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (1, 'admin', '暂停定时任务', 'io.renren.modules.job.controller.ScheduleJobController.pause()', '[1,2]', 33, '0:0:0:0:0:0:0:1', '2018-02-23 10:49:47');
INSERT INTO `sys_log` VALUES (2, 'admin', '删除定时任务', 'io.renren.modules.job.controller.ScheduleJobController.delete()', '[1,2]', 45, '0:0:0:0:0:0:0:1', '2018-02-23 10:49:53');
INSERT INTO `sys_log` VALUES (3, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '{\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"基础配置\",\"type\":0,\"orderNum\":0}', 9, '0:0:0:0:0:0:0:1', '2018-02-24 11:28:39');
INSERT INTO `sys_log` VALUES (4, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '{\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"曲库管理\",\"type\":0,\"orderNum\":1}', 8, '0:0:0:0:0:0:0:1', '2018-02-24 11:29:01');
INSERT INTO `sys_log` VALUES (5, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '{\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"推荐配置\",\"type\":0,\"orderNum\":0}', 9, '0:0:0:0:0:0:0:1', '2018-02-24 11:29:34');
INSERT INTO `sys_log` VALUES (6, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '{\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"推荐单曲配置\",\"type\":0,\"orderNum\":0}', 10, '0:0:0:0:0:0:0:1', '2018-02-24 11:29:59');
INSERT INTO `sys_log` VALUES (7, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":128,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"推荐曲集配置\",\"type\":0,\"orderNum\":0}', 10, '0:0:0:0:0:0:0:1', '2018-02-24 11:30:06');
INSERT INTO `sys_log` VALUES (8, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '{\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"最新配置\",\"type\":0,\"orderNum\":1}', 10, '0:0:0:0:0:0:0:1', '2018-02-24 11:30:35');
INSERT INTO `sys_log` VALUES (9, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '129', 20, '0:0:0:0:0:0:0:1', '2018-02-24 11:30:51');
INSERT INTO `sys_log` VALUES (10, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":128,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"推荐配置\",\"type\":0,\"orderNum\":0}', 10, '0:0:0:0:0:0:0:1', '2018-02-24 11:30:59');
INSERT INTO `sys_log` VALUES (11, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '{\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"教程配置\",\"type\":0,\"orderNum\":2}', 7, '0:0:0:0:0:0:0:1', '2018-02-24 11:31:29');
INSERT INTO `sys_log` VALUES (12, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":131,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"教程管理\",\"type\":0,\"orderNum\":2}', 8, '0:0:0:0:0:0:0:1', '2018-02-24 11:31:48');
INSERT INTO `sys_log` VALUES (13, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '131', 12, '0:0:0:0:0:0:0:1', '2018-02-24 11:32:53');
INSERT INTO `sys_log` VALUES (14, 'admin', '保存用户', 'io.renren.modules.sys.controller.SysUserController.save()', '{\"userId\":2,\"username\":\"test\",\"password\":\"d5955a3d316a0d9226f6eafcc6306419ccba903890b18a2f85338e4c275f4a65\",\"salt\":\"mqvReF5u6p3irIbnX6TL\",\"email\":\"1@q.com\",\"mobile\":\"1\",\"status\":1,\"roleIdList\":[],\"createUserId\":1,\"createTime\":\"Mar 23, 2018 9:52:35 AM\"}', 174, '49.66.149.236', '2018-03-23 09:52:35');
INSERT INTO `sys_log` VALUES (15, 'admin', '保存角色', 'io.renren.modules.sys.controller.SysRoleController.save()', '{\"roleId\":1,\"roleName\":\"管理\",\"remark\":\"管理\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,30,29,126,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,131,132,133,134,135,127,56,57,58,59,60,71,72,73,74,75,128,66,67,68,69,70,81,82,83,84,85,130,61,62,63,64,65,76,77,78,79,80,106,107,108,109,110],\"createTime\":\"Mar 23, 2018 9:53:30 AM\"}', 76, '49.66.149.236', '2018-03-23 09:53:30');
INSERT INTO `sys_log` VALUES (16, 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"test\",\"salt\":\"mqvReF5u6p3irIbnX6TL\",\"email\":\"1@q.com\",\"mobile\":\"1\",\"status\":1,\"roleIdList\":[1],\"createUserId\":1,\"createTime\":\"Mar 23, 2018 9:52:35 AM\"}', 35, '49.66.149.236', '2018-03-23 09:53:37');
INSERT INTO `sys_log` VALUES (17, 'admin', '保存角色', 'io.renren.modules.sys.controller.SysRoleController.save()', '{\"roleId\":2,\"roleName\":\"曲库管理\",\"createUserId\":1,\"menuIdList\":[126,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,131,132,133,134,135,127,56,57,58,59,60,71,72,73,74,75,128,66,67,68,69,70,81,82,83,84,85,130,61,62,63,64,65,76,77,78,79,80,106,107,108,109,110],\"createTime\":\"Apr 6, 2018 3:29:46 PM\"}', 107, '223.64.236.160', '2018-04-06 15:29:47');
INSERT INTO `sys_log` VALUES (18, 'admin', '保存用户', 'io.renren.modules.sys.controller.SysUserController.save()', '{\"userId\":3,\"username\":\"baoye\",\"password\":\"d6d9cde6195b3630827e41f816c13d78ce9ef15bf8cd80b075f72b707f076220\",\"salt\":\"8BrfgJVH6WdXvBm799hA\",\"email\":\"123456@qq.com\",\"mobile\":\"18118895586\",\"status\":1,\"roleIdList\":[2],\"createUserId\":1,\"createTime\":\"Apr 6, 2018 3:30:14 PM\"}', 77, '223.64.236.160', '2018-04-06 15:30:15');
INSERT INTO `sys_log` VALUES (19, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":1,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"系统管理\",\"type\":0,\"icon\":\"fa fa-cog\",\"orderNum\":20}', 7, '117.88.153.40', '2018-04-09 13:57:34');
INSERT INTO `sys_log` VALUES (20, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":127,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"曲库管理\",\"type\":0,\"orderNum\":15}', 7, '117.88.153.40', '2018-04-09 13:57:55');
INSERT INTO `sys_log` VALUES (21, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":126,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"基础配置\",\"type\":0,\"orderNum\":30}', 6, '117.88.153.40', '2018-04-09 13:58:19');
INSERT INTO `sys_log` VALUES (22, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":1,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"系统管理\",\"type\":0,\"icon\":\"fa fa-cog\",\"orderNum\":45}', 6, '117.88.153.40', '2018-04-09 13:58:29');
INSERT INTO `sys_log` VALUES (23, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":36,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"app用户\",\"url\":\"modules/sys/appuser.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 11, '117.88.153.40', '2018-04-09 14:00:05');
INSERT INTO `sys_log` VALUES (24, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":36,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"app用户\",\"url\":\"modules/sys/appuser.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":3}', 9, '117.88.153.40', '2018-04-09 14:05:28');
INSERT INTO `sys_log` VALUES (25, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":4,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"菜单管理\",\"url\":\"modules/sys/menu.html\",\"type\":1,\"icon\":\"fa fa-th-list\",\"orderNum\":4}', 10, '117.88.153.40', '2018-04-09 14:05:53');
INSERT INTO `sys_log` VALUES (26, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":27,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"参数管理\",\"url\":\"modules/sys/config.html\",\"perms\":\"sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete\",\"type\":1,\"icon\":\"fa fa-sun-o\",\"orderNum\":7}', 10, '117.88.153.40', '2018-04-09 14:06:27');
INSERT INTO `sys_log` VALUES (27, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":29,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"系统日志\",\"url\":\"modules/sys/log.html\",\"perms\":\"sys:log:list\",\"type\":1,\"icon\":\"fa fa-file-text-o\",\"orderNum\":8}', 10, '117.88.153.40', '2018-04-09 14:06:39');
INSERT INTO `sys_log` VALUES (28, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":29,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"系统日志\",\"url\":\"modules/sys/log.html\",\"perms\":\"sys:log:list\",\"type\":1,\"icon\":\"fa fa-file-text-o\",\"orderNum\":8}', 10, '117.88.153.40', '2018-04-09 14:06:40');
INSERT INTO `sys_log` VALUES (29, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":29,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"系统日志\",\"url\":\"modules/sys/log.html\",\"perms\":\"sys:log:list\",\"type\":1,\"icon\":\"fa fa-file-text-o\",\"orderNum\":8}', 10, '117.88.153.40', '2018-04-09 14:06:41');
INSERT INTO `sys_log` VALUES (30, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":36,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"用户管理\",\"url\":\"modules/sys/appuser.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":3}', 10, '117.88.153.40', '2018-04-09 14:07:18');
INSERT INTO `sys_log` VALUES (31, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":131,\"parentId\":126,\"parentName\":\"基础配置\",\"name\":\"用户反馈\",\"url\":\"modules/sys/feedback.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":1}', 10, '117.88.153.40', '2018-04-09 14:08:09');
INSERT INTO `sys_log` VALUES (32, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":51,\"parentId\":126,\"parentName\":\"基础配置\",\"name\":\"搜索词管理\",\"url\":\"modules/sys/search.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":2}', 10, '117.88.153.40', '2018-04-09 14:08:23');
INSERT INTO `sys_log` VALUES (33, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":46,\"parentId\":126,\"parentName\":\"基础配置\",\"name\":\"banner管理\",\"url\":\"modules/sys/banner.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":3}', 12, '117.88.153.40', '2018-04-09 14:08:33');
INSERT INTO `sys_log` VALUES (34, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":66,\"parentId\":128,\"parentName\":\"推荐配置\",\"name\":\"推荐单曲顺序\",\"url\":\"modules/sys/songrecommend.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 10, '117.88.153.40', '2018-04-09 14:29:51');
INSERT INTO `sys_log` VALUES (35, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":81,\"parentId\":128,\"parentName\":\"推荐配置\",\"name\":\"推荐专辑顺序\",\"url\":\"modules/sys/songsetrecommend.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 10, '117.88.153.40', '2018-04-09 14:30:11');
INSERT INTO `sys_log` VALUES (36, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":81,\"parentId\":128,\"parentName\":\"推荐配置\",\"name\":\"推荐专辑顺序\",\"url\":\"modules/sys/songsetrecommend.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 10, '117.88.153.40', '2018-04-09 14:30:12');
INSERT INTO `sys_log` VALUES (37, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":128,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"专辑单曲顺序\",\"type\":0,\"orderNum\":3}', 10, '117.88.153.40', '2018-04-09 14:30:59');
INSERT INTO `sys_log` VALUES (38, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":128,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"【推荐】顺序设置\",\"type\":0,\"orderNum\":3}', 10, '117.88.153.40', '2018-04-09 14:33:27');
INSERT INTO `sys_log` VALUES (39, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":130,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"【最新】顺序设置\",\"type\":0,\"orderNum\":4}', 11, '117.88.153.40', '2018-04-09 14:33:46');
INSERT INTO `sys_log` VALUES (40, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":61,\"parentId\":130,\"parentName\":\"【最新】顺序设置\",\"name\":\"单曲顺序\",\"url\":\"modules/sys/songnew.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 10, '117.88.153.40', '2018-04-09 14:34:18');
INSERT INTO `sys_log` VALUES (41, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":76,\"parentId\":130,\"parentName\":\"【最新】顺序设置\",\"name\":\"专辑顺序\",\"url\":\"modules/sys/songsetnew.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 12, '117.88.153.40', '2018-04-09 14:34:32');
INSERT INTO `sys_log` VALUES (42, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":66,\"parentId\":128,\"parentName\":\"【推荐】顺序设置\",\"name\":\"单曲顺序\",\"url\":\"modules/sys/songrecommend.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 12, '117.88.153.40', '2018-04-09 14:34:47');
INSERT INTO `sys_log` VALUES (43, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":66,\"parentId\":128,\"parentName\":\"【推荐】顺序设置\",\"name\":\"单曲顺序\",\"url\":\"modules/sys/songrecommend.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 11, '117.88.153.40', '2018-04-09 14:34:47');
INSERT INTO `sys_log` VALUES (44, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":81,\"parentId\":128,\"parentName\":\"【推荐】顺序设置\",\"name\":\"专辑顺序\",\"url\":\"modules/sys/songsetrecommend.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 11, '117.88.153.40', '2018-04-09 14:34:56');
INSERT INTO `sys_log` VALUES (45, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":46,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"Banner管理\",\"url\":\"modules/sys/banner.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":3}', 13, '117.88.153.40', '2018-04-09 15:00:03');
INSERT INTO `sys_log` VALUES (46, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":56,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"单曲管理\",\"url\":\"modules/sys/song.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":0}', 10, '117.88.153.40', '2018-04-09 15:00:44');
INSERT INTO `sys_log` VALUES (47, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":71,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"专辑管理\",\"url\":\"modules/sys/songset.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":1}', 12, '117.88.153.40', '2018-04-09 15:00:54');
INSERT INTO `sys_log` VALUES (48, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"弹框广告管理\",\"url\":\"modules/sys/ad.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":6}', 8, '117.88.153.40', '2018-04-09 15:01:52');
INSERT INTO `sys_log` VALUES (49, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":46,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"Banner管理\",\"url\":\"modules/sys/banner.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":5}', 12, '117.88.153.40', '2018-04-09 15:03:22');
INSERT INTO `sys_log` VALUES (50, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":56,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"单曲管理\",\"url\":\"modules/sys/song.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":10}', 12, '117.88.153.40', '2018-04-09 15:03:34');
INSERT INTO `sys_log` VALUES (51, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":106,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"教程管理\",\"url\":\"modules/sys/teach.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":15}', 12, '117.88.153.40', '2018-04-09 15:03:55');
INSERT INTO `sys_log` VALUES (52, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":71,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"专辑管理\",\"url\":\"modules/sys/songset.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":10}', 12, '117.88.153.40', '2018-04-09 15:04:13');
INSERT INTO `sys_log` VALUES (53, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":71,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"专辑管理\",\"url\":\"modules/sys/songset.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":15}', 10, '117.88.153.40', '2018-04-09 15:06:19');
INSERT INTO `sys_log` VALUES (54, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":56,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"单曲管理\",\"url\":\"modules/sys/song.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":15}', 12, '117.88.153.40', '2018-04-09 15:06:31');
INSERT INTO `sys_log` VALUES (55, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":71,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"专辑管理\",\"url\":\"modules/sys/songset.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":10}', 12, '117.88.153.40', '2018-04-09 15:07:11');
INSERT INTO `sys_log` VALUES (56, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":106,\"parentId\":127,\"parentName\":\"曲库管理\",\"name\":\"教程管理\",\"url\":\"modules/sys/teach.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":20}', 12, '117.88.153.40', '2018-04-09 15:07:24');
INSERT INTO `sys_log` VALUES (57, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":41,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"弹框广告管理\",\"url\":\"modules/sys/ad.html\",\"type\":1,\"icon\":\"\",\"orderNum\":6}', 9, '117.88.153.40', '2018-04-09 15:15:20');
INSERT INTO `sys_log` VALUES (58, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":1,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"系统管理\",\"type\":0,\"icon\":\"\",\"orderNum\":45}', 8, '117.88.153.40', '2018-04-09 15:15:38');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, '', 45);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'modules/sys/user.html', NULL, 1, 'fa fa-user', 1);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'modules/sys/role.html', NULL, 1, 'fa fa-user-secret', 2);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'modules/sys/menu.html', NULL, 1, 'fa fa-th-list', 4);
INSERT INTO `sys_menu` VALUES (5, 1, 'SQL监控', 'druid/sql.html', NULL, 1, 'fa fa-bug', 4);
INSERT INTO `sys_menu` VALUES (6, 1, '定时任务', 'modules/job/schedule.html', NULL, 1, 'fa fa-tasks', 5);
INSERT INTO `sys_menu` VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '参数管理', 'modules/sys/config.html', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'fa fa-sun-o', 7);
INSERT INTO `sys_menu` VALUES (29, 1, '系统日志', 'modules/sys/log.html', 'sys:log:list', 1, 'fa fa-file-text-o', 8);
INSERT INTO `sys_menu` VALUES (30, 1, '文件上传', 'modules/oss/oss.html', 'sys:oss:all', 1, 'fa fa-file-image-o', 6);
INSERT INTO `sys_menu` VALUES (36, 1, '用户管理', 'modules/sys/appuser.html', NULL, 1, 'fa fa-file-code-o', 3);
INSERT INTO `sys_menu` VALUES (37, 36, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (38, 36, '新增', NULL, 'sys:user:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (39, 36, '修改', NULL, 'sys:user:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (40, 36, '删除', NULL, 'sys:user:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (41, 0, '弹框广告管理', 'modules/sys/ad.html', NULL, 1, '', 6);
INSERT INTO `sys_menu` VALUES (42, 41, '查看', NULL, 'sys:ad:list,sys:ad:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (43, 41, '新增', NULL, 'sys:ad:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (44, 41, '修改', NULL, 'sys:ad:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (45, 41, '删除', NULL, 'sys:ad:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (46, 127, 'Banner管理', 'modules/sys/banner.html', NULL, 1, 'fa fa-file-code-o', 5);
INSERT INTO `sys_menu` VALUES (47, 46, '查看', NULL, 'sys:banner:list,sys:banner:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (48, 46, '新增', NULL, 'sys:banner:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (49, 46, '修改', NULL, 'sys:banner:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (50, 46, '删除', NULL, 'sys:banner:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (51, 126, '搜索词管理', 'modules/sys/search.html', NULL, 1, 'fa fa-file-code-o', 2);
INSERT INTO `sys_menu` VALUES (52, 51, '查看', NULL, 'sys:search:list,sys:search:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (53, 51, '新增', NULL, 'sys:search:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (54, 51, '修改', NULL, 'sys:search:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (55, 51, '删除', NULL, 'sys:search:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (56, 127, '单曲管理', 'modules/sys/song.html', NULL, 1, 'fa fa-file-code-o', 15);
INSERT INTO `sys_menu` VALUES (57, 56, '查看', NULL, 'sys:song:list,sys:song:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (58, 56, '新增', NULL, 'sys:song:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (59, 56, '修改', NULL, 'sys:song:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (60, 56, '删除', NULL, 'sys:song:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (61, 130, '单曲顺序', 'modules/sys/songnew.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (62, 61, '查看', NULL, 'sys:songnew:list,sys:songnew:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (63, 61, '新增', NULL, 'sys:songnew:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (64, 61, '修改', NULL, 'sys:songnew:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (65, 61, '删除', NULL, 'sys:songnew:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (66, 128, '单曲顺序', 'modules/sys/songrecommend.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (67, 66, '查看', NULL, 'sys:songrecommend:list,sys:songrecommend:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (68, 66, '新增', NULL, 'sys:songrecommend:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (69, 66, '修改', NULL, 'sys:songrecommend:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (70, 66, '删除', NULL, 'sys:songrecommend:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (71, 127, '专辑管理', 'modules/sys/songset.html', NULL, 1, 'fa fa-file-code-o', 10);
INSERT INTO `sys_menu` VALUES (72, 71, '查看', NULL, 'sys:songset:list,sys:songset:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (73, 71, '新增', NULL, 'sys:songset:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (74, 71, '修改', NULL, 'sys:songset:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (75, 71, '删除', NULL, 'sys:songset:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (76, 130, '专辑顺序', 'modules/sys/songsetnew.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (77, 76, '查看', NULL, 'sys:songsetnew:list,sys:songsetnew:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (78, 76, '新增', NULL, 'sys:songsetnew:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (79, 76, '修改', NULL, 'sys:songsetnew:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (80, 76, '删除', NULL, 'sys:songsetnew:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (81, 128, '专辑顺序', 'modules/sys/songsetrecommend.html', NULL, 1, 'fa fa-file-code-o', 6);
INSERT INTO `sys_menu` VALUES (82, 81, '查看', NULL, 'sys:songsetrecommend:list,sys:songsetrecommend:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (83, 81, '新增', NULL, 'sys:songsetrecommend:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (84, 81, '修改', NULL, 'sys:songsetrecommend:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (85, 81, '删除', NULL, 'sys:songsetrecommend:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (106, 127, '教程管理', 'modules/sys/teach.html', NULL, 1, 'fa fa-file-code-o', 20);
INSERT INTO `sys_menu` VALUES (107, 106, '查看', NULL, 'sys:teach:list,sys:teach:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (108, 106, '新增', NULL, 'sys:teach:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (109, 106, '修改', NULL, 'sys:teach:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (110, 106, '删除', NULL, 'sys:teach:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (126, 0, '基础配置', NULL, NULL, 0, NULL, 30);
INSERT INTO `sys_menu` VALUES (127, 0, '曲库管理', NULL, NULL, 0, NULL, 15);
INSERT INTO `sys_menu` VALUES (128, 127, '【推荐】顺序设置', NULL, NULL, 0, NULL, 3);
INSERT INTO `sys_menu` VALUES (130, 127, '【最新】顺序设置', NULL, NULL, 0, NULL, 4);
INSERT INTO `sys_menu` VALUES (131, 126, '用户反馈', 'modules/sys/feedback.html', NULL, 1, 'fa fa-file-code-o', 1);
INSERT INTO `sys_menu` VALUES (132, 131, '查看', NULL, 'sys:feedback:list,sys:feedback:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (133, 131, '新增', NULL, 'sys:feedback:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (134, 131, '修改', NULL, 'sys:feedback:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (135, 131, '删除', NULL, 'sys:feedback:delete', 2, NULL, 6);
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件上传';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '管理', '管理', 1, '2018-03-23 09:53:30');
INSERT INTO `sys_role` VALUES (2, '曲库管理', NULL, 1, '2018-04-06 15:29:47');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1, 1, 1);
INSERT INTO `sys_role_menu` VALUES (2, 1, 2);
INSERT INTO `sys_role_menu` VALUES (3, 1, 15);
INSERT INTO `sys_role_menu` VALUES (4, 1, 16);
INSERT INTO `sys_role_menu` VALUES (5, 1, 17);
INSERT INTO `sys_role_menu` VALUES (6, 1, 18);
INSERT INTO `sys_role_menu` VALUES (7, 1, 3);
INSERT INTO `sys_role_menu` VALUES (8, 1, 19);
INSERT INTO `sys_role_menu` VALUES (9, 1, 20);
INSERT INTO `sys_role_menu` VALUES (10, 1, 21);
INSERT INTO `sys_role_menu` VALUES (11, 1, 22);
INSERT INTO `sys_role_menu` VALUES (12, 1, 4);
INSERT INTO `sys_role_menu` VALUES (13, 1, 23);
INSERT INTO `sys_role_menu` VALUES (14, 1, 24);
INSERT INTO `sys_role_menu` VALUES (15, 1, 25);
INSERT INTO `sys_role_menu` VALUES (16, 1, 26);
INSERT INTO `sys_role_menu` VALUES (17, 1, 5);
INSERT INTO `sys_role_menu` VALUES (18, 1, 6);
INSERT INTO `sys_role_menu` VALUES (19, 1, 7);
INSERT INTO `sys_role_menu` VALUES (20, 1, 8);
INSERT INTO `sys_role_menu` VALUES (21, 1, 9);
INSERT INTO `sys_role_menu` VALUES (22, 1, 10);
INSERT INTO `sys_role_menu` VALUES (23, 1, 11);
INSERT INTO `sys_role_menu` VALUES (24, 1, 12);
INSERT INTO `sys_role_menu` VALUES (25, 1, 13);
INSERT INTO `sys_role_menu` VALUES (26, 1, 14);
INSERT INTO `sys_role_menu` VALUES (27, 1, 27);
INSERT INTO `sys_role_menu` VALUES (28, 1, 30);
INSERT INTO `sys_role_menu` VALUES (29, 1, 29);
INSERT INTO `sys_role_menu` VALUES (30, 1, 126);
INSERT INTO `sys_role_menu` VALUES (31, 1, 36);
INSERT INTO `sys_role_menu` VALUES (32, 1, 37);
INSERT INTO `sys_role_menu` VALUES (33, 1, 38);
INSERT INTO `sys_role_menu` VALUES (34, 1, 39);
INSERT INTO `sys_role_menu` VALUES (35, 1, 40);
INSERT INTO `sys_role_menu` VALUES (36, 1, 41);
INSERT INTO `sys_role_menu` VALUES (37, 1, 42);
INSERT INTO `sys_role_menu` VALUES (38, 1, 43);
INSERT INTO `sys_role_menu` VALUES (39, 1, 44);
INSERT INTO `sys_role_menu` VALUES (40, 1, 45);
INSERT INTO `sys_role_menu` VALUES (41, 1, 46);
INSERT INTO `sys_role_menu` VALUES (42, 1, 47);
INSERT INTO `sys_role_menu` VALUES (43, 1, 48);
INSERT INTO `sys_role_menu` VALUES (44, 1, 49);
INSERT INTO `sys_role_menu` VALUES (45, 1, 50);
INSERT INTO `sys_role_menu` VALUES (46, 1, 51);
INSERT INTO `sys_role_menu` VALUES (47, 1, 52);
INSERT INTO `sys_role_menu` VALUES (48, 1, 53);
INSERT INTO `sys_role_menu` VALUES (49, 1, 54);
INSERT INTO `sys_role_menu` VALUES (50, 1, 55);
INSERT INTO `sys_role_menu` VALUES (51, 1, 131);
INSERT INTO `sys_role_menu` VALUES (52, 1, 132);
INSERT INTO `sys_role_menu` VALUES (53, 1, 133);
INSERT INTO `sys_role_menu` VALUES (54, 1, 134);
INSERT INTO `sys_role_menu` VALUES (55, 1, 135);
INSERT INTO `sys_role_menu` VALUES (56, 1, 127);
INSERT INTO `sys_role_menu` VALUES (57, 1, 56);
INSERT INTO `sys_role_menu` VALUES (58, 1, 57);
INSERT INTO `sys_role_menu` VALUES (59, 1, 58);
INSERT INTO `sys_role_menu` VALUES (60, 1, 59);
INSERT INTO `sys_role_menu` VALUES (61, 1, 60);
INSERT INTO `sys_role_menu` VALUES (62, 1, 71);
INSERT INTO `sys_role_menu` VALUES (63, 1, 72);
INSERT INTO `sys_role_menu` VALUES (64, 1, 73);
INSERT INTO `sys_role_menu` VALUES (65, 1, 74);
INSERT INTO `sys_role_menu` VALUES (66, 1, 75);
INSERT INTO `sys_role_menu` VALUES (67, 1, 128);
INSERT INTO `sys_role_menu` VALUES (68, 1, 66);
INSERT INTO `sys_role_menu` VALUES (69, 1, 67);
INSERT INTO `sys_role_menu` VALUES (70, 1, 68);
INSERT INTO `sys_role_menu` VALUES (71, 1, 69);
INSERT INTO `sys_role_menu` VALUES (72, 1, 70);
INSERT INTO `sys_role_menu` VALUES (73, 1, 81);
INSERT INTO `sys_role_menu` VALUES (74, 1, 82);
INSERT INTO `sys_role_menu` VALUES (75, 1, 83);
INSERT INTO `sys_role_menu` VALUES (76, 1, 84);
INSERT INTO `sys_role_menu` VALUES (77, 1, 85);
INSERT INTO `sys_role_menu` VALUES (78, 1, 130);
INSERT INTO `sys_role_menu` VALUES (79, 1, 61);
INSERT INTO `sys_role_menu` VALUES (80, 1, 62);
INSERT INTO `sys_role_menu` VALUES (81, 1, 63);
INSERT INTO `sys_role_menu` VALUES (82, 1, 64);
INSERT INTO `sys_role_menu` VALUES (83, 1, 65);
INSERT INTO `sys_role_menu` VALUES (84, 1, 76);
INSERT INTO `sys_role_menu` VALUES (85, 1, 77);
INSERT INTO `sys_role_menu` VALUES (86, 1, 78);
INSERT INTO `sys_role_menu` VALUES (87, 1, 79);
INSERT INTO `sys_role_menu` VALUES (88, 1, 80);
INSERT INTO `sys_role_menu` VALUES (89, 1, 106);
INSERT INTO `sys_role_menu` VALUES (90, 1, 107);
INSERT INTO `sys_role_menu` VALUES (91, 1, 108);
INSERT INTO `sys_role_menu` VALUES (92, 1, 109);
INSERT INTO `sys_role_menu` VALUES (93, 1, 110);
INSERT INTO `sys_role_menu` VALUES (94, 2, 126);
INSERT INTO `sys_role_menu` VALUES (95, 2, 36);
INSERT INTO `sys_role_menu` VALUES (96, 2, 37);
INSERT INTO `sys_role_menu` VALUES (97, 2, 38);
INSERT INTO `sys_role_menu` VALUES (98, 2, 39);
INSERT INTO `sys_role_menu` VALUES (99, 2, 40);
INSERT INTO `sys_role_menu` VALUES (100, 2, 41);
INSERT INTO `sys_role_menu` VALUES (101, 2, 42);
INSERT INTO `sys_role_menu` VALUES (102, 2, 43);
INSERT INTO `sys_role_menu` VALUES (103, 2, 44);
INSERT INTO `sys_role_menu` VALUES (104, 2, 45);
INSERT INTO `sys_role_menu` VALUES (105, 2, 46);
INSERT INTO `sys_role_menu` VALUES (106, 2, 47);
INSERT INTO `sys_role_menu` VALUES (107, 2, 48);
INSERT INTO `sys_role_menu` VALUES (108, 2, 49);
INSERT INTO `sys_role_menu` VALUES (109, 2, 50);
INSERT INTO `sys_role_menu` VALUES (110, 2, 51);
INSERT INTO `sys_role_menu` VALUES (111, 2, 52);
INSERT INTO `sys_role_menu` VALUES (112, 2, 53);
INSERT INTO `sys_role_menu` VALUES (113, 2, 54);
INSERT INTO `sys_role_menu` VALUES (114, 2, 55);
INSERT INTO `sys_role_menu` VALUES (115, 2, 131);
INSERT INTO `sys_role_menu` VALUES (116, 2, 132);
INSERT INTO `sys_role_menu` VALUES (117, 2, 133);
INSERT INTO `sys_role_menu` VALUES (118, 2, 134);
INSERT INTO `sys_role_menu` VALUES (119, 2, 135);
INSERT INTO `sys_role_menu` VALUES (120, 2, 127);
INSERT INTO `sys_role_menu` VALUES (121, 2, 56);
INSERT INTO `sys_role_menu` VALUES (122, 2, 57);
INSERT INTO `sys_role_menu` VALUES (123, 2, 58);
INSERT INTO `sys_role_menu` VALUES (124, 2, 59);
INSERT INTO `sys_role_menu` VALUES (125, 2, 60);
INSERT INTO `sys_role_menu` VALUES (126, 2, 71);
INSERT INTO `sys_role_menu` VALUES (127, 2, 72);
INSERT INTO `sys_role_menu` VALUES (128, 2, 73);
INSERT INTO `sys_role_menu` VALUES (129, 2, 74);
INSERT INTO `sys_role_menu` VALUES (130, 2, 75);
INSERT INTO `sys_role_menu` VALUES (131, 2, 128);
INSERT INTO `sys_role_menu` VALUES (132, 2, 66);
INSERT INTO `sys_role_menu` VALUES (133, 2, 67);
INSERT INTO `sys_role_menu` VALUES (134, 2, 68);
INSERT INTO `sys_role_menu` VALUES (135, 2, 69);
INSERT INTO `sys_role_menu` VALUES (136, 2, 70);
INSERT INTO `sys_role_menu` VALUES (137, 2, 81);
INSERT INTO `sys_role_menu` VALUES (138, 2, 82);
INSERT INTO `sys_role_menu` VALUES (139, 2, 83);
INSERT INTO `sys_role_menu` VALUES (140, 2, 84);
INSERT INTO `sys_role_menu` VALUES (141, 2, 85);
INSERT INTO `sys_role_menu` VALUES (142, 2, 130);
INSERT INTO `sys_role_menu` VALUES (143, 2, 61);
INSERT INTO `sys_role_menu` VALUES (144, 2, 62);
INSERT INTO `sys_role_menu` VALUES (145, 2, 63);
INSERT INTO `sys_role_menu` VALUES (146, 2, 64);
INSERT INTO `sys_role_menu` VALUES (147, 2, 65);
INSERT INTO `sys_role_menu` VALUES (148, 2, 76);
INSERT INTO `sys_role_menu` VALUES (149, 2, 77);
INSERT INTO `sys_role_menu` VALUES (150, 2, 78);
INSERT INTO `sys_role_menu` VALUES (151, 2, 79);
INSERT INTO `sys_role_menu` VALUES (152, 2, 80);
INSERT INTO `sys_role_menu` VALUES (153, 2, 106);
INSERT INTO `sys_role_menu` VALUES (154, 2, 107);
INSERT INTO `sys_role_menu` VALUES (155, 2, 108);
INSERT INTO `sys_role_menu` VALUES (156, 2, 109);
INSERT INTO `sys_role_menu` VALUES (157, 2, 110);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', 1, 1, '2016-11-11 11:11:11');
INSERT INTO `sys_user` VALUES (2, 'test', 'd5955a3d316a0d9226f6eafcc6306419ccba903890b18a2f85338e4c275f4a65', 'mqvReF5u6p3irIbnX6TL', '1@q.com', '1', 1, 1, '2018-03-23 09:52:35');
INSERT INTO `sys_user` VALUES (3, 'baoye', 'd6d9cde6195b3630827e41f816c13d78ce9ef15bf8cd80b075f72b707f076220', '8BrfgJVH6WdXvBm799hA', '123456@qq.com', '18118895586', 1, 1, '2018-04-06 15:30:15');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, 2, 1);
INSERT INTO `sys_user_role` VALUES (2, 3, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `token` (`token`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES (1, 'c3da61109885621d69be97d9596a2268', '2018-05-08 01:44:32', '2018-05-07 13:44:32');
INSERT INTO `sys_user_token` VALUES (2, 'f273ab031eca9a6438edef345aa07165', '2018-05-08 01:26:19', '2018-05-07 13:26:19');
INSERT INTO `sys_user_token` VALUES (3, '0863a5993a2f0a4c2c28faa6c082277d', '2018-04-07 03:30:29', '2018-04-06 15:30:29');
COMMIT;

-- ----------------------------
-- Table structure for tb_ad
-- ----------------------------
DROP TABLE IF EXISTS `tb_ad`;
CREATE TABLE `tb_ad` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `img` varchar(100) NOT NULL COMMENT '图片',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `status` int(2) NOT NULL COMMENT '状态',
  `release_time` datetime DEFAULT NULL COMMENT '上架时间',
  `url` varchar(100) NOT NULL COMMENT '链接',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_ad
-- ----------------------------
BEGIN;
INSERT INTO `tb_ad` VALUES (1, '弹窗广告', '1523257952136.jpg', 3, 1, '2018-04-09 15:12:43', 'www.tinefu.com', '2018-02-28 15:43:13', '2018-04-09 15:12:43');
COMMIT;

-- ----------------------------
-- Table structure for tb_banner
-- ----------------------------
DROP TABLE IF EXISTS `tb_banner`;
CREATE TABLE `tb_banner` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `img` varchar(100) NOT NULL COMMENT '图片',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `status` int(2) NOT NULL COMMENT '状态',
  `release_time` datetime DEFAULT NULL COMMENT '上架时间',
  `url_type` varchar(20) NOT NULL COMMENT '链接类型',
  `url` varchar(100) NOT NULL COMMENT '链接',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_banner
-- ----------------------------
BEGIN;
INSERT INTO `tb_banner` VALUES (2, '汤普森', '1523257714703.jpg', 1, 1, '2018-05-06 20:25:43', 'song', '1', '2018-03-15 17:19:29', '2018-05-06 20:25:43');
INSERT INTO `tb_banner` VALUES (3, '拜厄', '1523257704499.jpg', 2, 1, '2018-05-06 20:22:12', 'songset', '1', '2018-03-23 09:55:32', '2018-05-06 20:22:12');
INSERT INTO `tb_banner` VALUES (4, '车尔尼599', '1523257730281.jpg', 3, 1, '2018-05-06 20:22:03', 'url', 'http://www.baidu.com', '2018-04-05 12:43:27', '2018-05-06 20:22:03');
COMMIT;

-- ----------------------------
-- Table structure for tb_code
-- ----------------------------
DROP TABLE IF EXISTS `tb_code`;
CREATE TABLE `tb_code` (
  `mobile` varchar(20) NOT NULL,
  `code` varchar(20) NOT NULL,
  `expire` bigint(20) NOT NULL,
  PRIMARY KEY (`mobile`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_code
-- ----------------------------
BEGIN;
INSERT INTO `tb_code` VALUES ('1', '601515', 1525672679901);
INSERT INTO `tb_code` VALUES ('13291869214', '742934', 1522752448089);
INSERT INTO `tb_code` VALUES ('13357720188', '470915', 1525310175558);
INSERT INTO `tb_code` VALUES ('13372508323', '757628', 1524794360281);
INSERT INTO `tb_code` VALUES ('13466665138', '666666', 1522749701164);
INSERT INTO `tb_code` VALUES ('13506171167', '53875', 1525672517067);
INSERT INTO `tb_code` VALUES ('13693329426', '757628', 1523952945654);
INSERT INTO `tb_code` VALUES ('13815898825', '470915', 1525550266465);
INSERT INTO `tb_code` VALUES ('13952009488', '780977', 1523519238186);
INSERT INTO `tb_code` VALUES ('15011001663', '20906', 1522907493740);
INSERT INTO `tb_code` VALUES ('15715153640', '780977', 1523438136492);
INSERT INTO `tb_code` VALUES ('15852800586', '666666', 1522045820144);
INSERT INTO `tb_code` VALUES ('15950450693', '757628', 1524807876670);
INSERT INTO `tb_code` VALUES ('15950450694', '20906', 1522936022599);
INSERT INTO `tb_code` VALUES ('15950450697', '20906', 1522936092999);
INSERT INTO `tb_code` VALUES ('17751528219', '20906', 1522932690281);
INSERT INTO `tb_code` VALUES ('18118895586', '757628', 1524798626632);
INSERT INTO `tb_code` VALUES ('18168896116', '666666', 1521703363040);
INSERT INTO `tb_code` VALUES ('18511831914', '20906', 1522810937593);
INSERT INTO `tb_code` VALUES ('18516276648', '470915', 1525529338369);
INSERT INTO `tb_code` VALUES ('18600231197', '666666', 1522745023590);
INSERT INTO `tb_code` VALUES ('18613155485', '470915', 1524911356858);
INSERT INTO `tb_code` VALUES ('2', '666666', 1521966538701);
INSERT INTO `tb_code` VALUES ('321', '666666', 1521698319517);
COMMIT;

-- ----------------------------
-- Table structure for tb_feedback
-- ----------------------------
DROP TABLE IF EXISTS `tb_feedback`;
CREATE TABLE `tb_feedback` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `content` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_feedback
-- ----------------------------
BEGIN;
INSERT INTO `tb_feedback` VALUES (1, 1, '问题', '为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看为什么界面这么好看', '2018-03-19 15:50:25');
INSERT INTO `tb_feedback` VALUES (2, 4, '123', '213', '2018-03-24 10:33:42');
INSERT INTO `tb_feedback` VALUES (3, 6, '功能', 'yuiuiui', '2018-03-26 22:24:34');
INSERT INTO `tb_feedback` VALUES (4, 6, '图片内容', '公共管理还可以咯了', '2018-04-01 04:45:50');
INSERT INTO `tb_feedback` VALUES (5, 6, '美观', '能不能做的更美观一些', '2018-04-06 14:11:45');
INSERT INTO `tb_feedback` VALUES (6, 6, '文字描述', '我擦，失眠了', '2018-04-09 03:38:28');
INSERT INTO `tb_feedback` VALUES (7, 16, '功能', 'Rwqrewrewqrewqrewqrwr', '2018-04-28 18:09:25');
INSERT INTO `tb_feedback` VALUES (8, 16, '图片内容', 'Uuuuuooooooooo', '2018-04-28 23:18:53');
INSERT INTO `tb_feedback` VALUES (9, 11, '其它', '苹果客户端测试\n多少内容才可以提交', '2018-05-03 09:18:20');
INSERT INTO `tb_feedback` VALUES (10, 17, '功能', '功能', '2018-05-03 19:43:20');
INSERT INTO `tb_feedback` VALUES (11, 17, '文字描述', '文字描述', '2018-05-05 22:57:49');
INSERT INTO `tb_feedback` VALUES (12, 18, '美观', '1来吃巴巴爸爸11哈哈啊吃', '2018-05-06 03:54:23');
COMMIT;

-- ----------------------------
-- Table structure for tb_history
-- ----------------------------
DROP TABLE IF EXISTS `tb_history`;
CREATE TABLE `tb_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `media_id` bigint(20) NOT NULL COMMENT '曲谱或视频id',
  `type` int(2) NOT NULL COMMENT '0曲谱 1视频',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_history
-- ----------------------------
BEGIN;
INSERT INTO `tb_history` VALUES (1, 6, 31, 1, '2018-03-30 21:35:53');
INSERT INTO `tb_history` VALUES (2, 6, 29, 1, '2018-03-30 22:27:15');
INSERT INTO `tb_history` VALUES (3, 6, 30, 1, '2018-03-30 22:51:51');
INSERT INTO `tb_history` VALUES (4, 6, 30, 1, '2018-03-31 08:43:26');
INSERT INTO `tb_history` VALUES (5, 6, 29, 1, '2018-03-31 20:45:44');
INSERT INTO `tb_history` VALUES (6, 6, 34, 1, '2018-03-31 20:46:46');
INSERT INTO `tb_history` VALUES (7, 6, 29, 1, '2018-03-31 21:00:27');
INSERT INTO `tb_history` VALUES (8, 6, 32, 1, '2018-03-31 21:00:29');
INSERT INTO `tb_history` VALUES (9, 6, 29, 1, '2018-03-31 21:00:43');
INSERT INTO `tb_history` VALUES (10, 6, 29, 1, '2018-03-31 21:01:23');
INSERT INTO `tb_history` VALUES (11, 6, 30, 1, '2018-03-31 21:01:25');
INSERT INTO `tb_history` VALUES (12, 6, 34, 1, '2018-03-31 21:01:30');
INSERT INTO `tb_history` VALUES (13, 6, 29, 1, '2018-03-31 21:01:36');
INSERT INTO `tb_history` VALUES (14, 6, 29, 1, '2018-03-31 21:02:03');
INSERT INTO `tb_history` VALUES (15, 6, 29, 1, '2018-03-31 21:02:41');
INSERT INTO `tb_history` VALUES (16, 6, 29, 1, '2018-03-31 21:02:48');
INSERT INTO `tb_history` VALUES (17, 6, 29, 1, '2018-03-31 21:02:55');
INSERT INTO `tb_history` VALUES (18, 6, 29, 1, '2018-03-31 21:03:09');
INSERT INTO `tb_history` VALUES (19, 6, 31, 1, '2018-03-31 21:03:34');
INSERT INTO `tb_history` VALUES (20, 6, 29, 1, '2018-04-01 00:39:27');
INSERT INTO `tb_history` VALUES (21, 6, 29, 1, '2018-04-01 00:41:38');
INSERT INTO `tb_history` VALUES (22, 6, 29, 1, '2018-04-01 00:43:41');
INSERT INTO `tb_history` VALUES (23, 6, 29, 1, '2018-04-01 00:44:14');
INSERT INTO `tb_history` VALUES (24, 6, 30, 1, '2018-04-01 01:31:56');
INSERT INTO `tb_history` VALUES (25, 6, 29, 1, '2018-04-01 01:32:05');
INSERT INTO `tb_history` VALUES (26, 6, 36, 1, '2018-04-03 01:25:21');
INSERT INTO `tb_history` VALUES (27, 6, 36, 1, '2018-04-03 02:00:37');
INSERT INTO `tb_history` VALUES (28, 6, 40, 1, '2018-04-03 23:07:01');
INSERT INTO `tb_history` VALUES (29, 6, 41, 1, '2018-04-03 23:07:27');
INSERT INTO `tb_history` VALUES (30, 6, 40, 1, '2018-04-03 23:08:26');
INSERT INTO `tb_history` VALUES (31, 6, 40, 1, '2018-04-03 23:11:01');
INSERT INTO `tb_history` VALUES (32, 6, 41, 1, '2018-04-03 23:11:09');
INSERT INTO `tb_history` VALUES (33, 6, 40, 1, '2018-04-03 23:20:38');
INSERT INTO `tb_history` VALUES (34, 6, 49, 1, '2018-04-03 23:24:56');
INSERT INTO `tb_history` VALUES (35, 6, 49, 1, '2018-04-04 01:17:49');
INSERT INTO `tb_history` VALUES (42, 4, 8, 2, '2018-04-04 10:28:56');
INSERT INTO `tb_history` VALUES (43, 4, 9, 2, '2018-04-04 10:33:19');
INSERT INTO `tb_history` VALUES (44, 12, 41, 1, '2018-04-04 10:58:53');
INSERT INTO `tb_history` VALUES (45, 12, 40, 1, '2018-04-04 11:00:15');
INSERT INTO `tb_history` VALUES (46, 6, 1, 2, '2018-04-05 00:38:27');
INSERT INTO `tb_history` VALUES (47, 6, 4, 2, '2018-04-05 00:47:49');
INSERT INTO `tb_history` VALUES (48, 6, 8, 2, '2018-04-05 00:55:13');
INSERT INTO `tb_history` VALUES (49, 6, 6, 2, '2018-04-05 00:55:31');
INSERT INTO `tb_history` VALUES (50, 6, 7, 2, '2018-04-05 16:48:42');
INSERT INTO `tb_history` VALUES (51, 11, 40, 1, '2018-04-06 15:10:59');
INSERT INTO `tb_history` VALUES (52, 6, 2, 2, '2018-04-06 16:57:47');
INSERT INTO `tb_history` VALUES (53, 6, 3, 2, '2018-04-06 16:57:50');
INSERT INTO `tb_history` VALUES (54, 10, 6, 2, '2018-04-09 11:02:51');
INSERT INTO `tb_history` VALUES (55, 10, 1, 2, '2018-04-09 11:09:18');
INSERT INTO `tb_history` VALUES (56, 11, 5, 2, '2018-04-09 11:53:54');
INSERT INTO `tb_history` VALUES (57, 11, 2, 2, '2018-04-09 11:54:02');
INSERT INTO `tb_history` VALUES (58, 11, 3, 2, '2018-04-09 11:58:19');
INSERT INTO `tb_history` VALUES (59, 10, 4, 2, '2018-04-09 12:03:57');
INSERT INTO `tb_history` VALUES (60, 10, 8, 2, '2018-04-09 13:51:08');
INSERT INTO `tb_history` VALUES (61, 11, 10, 2, '2018-04-09 14:43:41');
INSERT INTO `tb_history` VALUES (62, 11, 61, 1, '2018-04-09 14:43:43');
INSERT INTO `tb_history` VALUES (63, 11, 1, 2, '2018-04-09 14:47:03');
INSERT INTO `tb_history` VALUES (64, 11, 64, 1, '2018-04-09 14:47:33');
INSERT INTO `tb_history` VALUES (65, 10, 2, 2, '2018-04-09 15:26:34');
INSERT INTO `tb_history` VALUES (66, 10, 5, 2, '2018-04-09 16:42:33');
INSERT INTO `tb_history` VALUES (67, 11, 7, 2, '2018-04-10 15:06:17');
INSERT INTO `tb_history` VALUES (68, 11, 68, 1, '2018-04-10 15:06:55');
INSERT INTO `tb_history` VALUES (69, 10, 3, 2, '2018-04-10 16:45:46');
INSERT INTO `tb_history` VALUES (70, 6, 5, 2, '2018-04-11 08:28:29');
INSERT INTO `tb_history` VALUES (71, 11, 4, 2, '2018-04-11 12:05:42');
INSERT INTO `tb_history` VALUES (72, 14, 1, 2, '2018-04-11 17:12:49');
INSERT INTO `tb_history` VALUES (73, 14, 7, 2, '2018-04-11 17:18:45');
INSERT INTO `tb_history` VALUES (74, 6, 10, 2, '2018-04-13 01:55:56');
INSERT INTO `tb_history` VALUES (75, 6, 68, 1, '2018-04-13 01:55:58');
INSERT INTO `tb_history` VALUES (76, 13, 8, 2, '2018-04-18 13:06:31');
INSERT INTO `tb_history` VALUES (77, 15, 7, 2, '2018-04-27 09:55:46');
INSERT INTO `tb_history` VALUES (78, 15, 8, 2, '2018-04-27 09:58:34');
INSERT INTO `tb_history` VALUES (79, 16, 5, 0, '2018-05-05 17:55:59');
INSERT INTO `tb_history` VALUES (80, 17, 7, 2, '2018-05-05 22:37:56');
INSERT INTO `tb_history` VALUES (81, 17, 10, 2, '2018-05-05 22:55:13');
INSERT INTO `tb_history` VALUES (82, 17, 5, 0, '2018-05-05 22:58:23');
INSERT INTO `tb_history` VALUES (83, 17, 6, 0, '2018-05-06 18:00:01');
INSERT INTO `tb_history` VALUES (84, 17, 7, 0, '2018-05-06 19:00:23');
INSERT INTO `tb_history` VALUES (85, 17, 4, 0, '2018-05-06 19:51:41');
INSERT INTO `tb_history` VALUES (86, 17, 1, 0, '2018-05-06 20:46:36');
INSERT INTO `tb_history` VALUES (87, 17, 8, 2, '2018-05-06 21:09:44');
INSERT INTO `tb_history` VALUES (88, 17, 2, 2, '2018-05-06 21:11:44');
INSERT INTO `tb_history` VALUES (89, 17, 3, 0, '2018-05-06 21:36:16');
INSERT INTO `tb_history` VALUES (90, 17, 5, 2, '2018-05-06 22:19:37');
INSERT INTO `tb_history` VALUES (91, 17, 1, 2, '2018-05-06 22:39:52');
COMMIT;

-- ----------------------------
-- Table structure for tb_search
-- ----------------------------
DROP TABLE IF EXISTS `tb_search`;
CREATE TABLE `tb_search` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `sort` int(2) DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_search
-- ----------------------------
BEGIN;
INSERT INTO `tb_search` VALUES (13, '梦中的婚礼', NULL, '2018-04-09 13:54:23');
INSERT INTO `tb_search` VALUES (14, '菊次郎的夏天', NULL, '2018-04-09 13:54:30');
INSERT INTO `tb_search` VALUES (15, '梦幻华尔兹', NULL, '2018-04-09 13:54:50');
INSERT INTO `tb_search` VALUES (17, '周杰伦', NULL, '2018-04-29 17:28:25');
INSERT INTO `tb_search` VALUES (18, '爱情', NULL, '2018-05-06 18:44:53');
COMMIT;

-- ----------------------------
-- Table structure for tb_song
-- ----------------------------
DROP TABLE IF EXISTS `tb_song`;
CREATE TABLE `tb_song` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `author` varchar(50) NOT NULL COMMENT '作者',
  `upload_user` varchar(50) NOT NULL COMMENT '上传者姓名',
  `release_time` datetime NOT NULL COMMENT '上架时间',
  `hard` int(2) NOT NULL COMMENT '难度',
  `opern` varchar(100) NOT NULL COMMENT '曲谱',
  `opern_name` varchar(100) NOT NULL COMMENT '曲谱名',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `type` int(2) NOT NULL,
  `img` varchar(100) NOT NULL COMMENT '图片',
  `introduce` varchar(100) NOT NULL COMMENT '简介',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_song
-- ----------------------------
BEGIN;
INSERT INTO `tb_song` VALUES (1, '贝多芬的忧伤', '王毅', '王毅', '2018-02-24 12:56:31', 4, '1519453463379.xml', 'artifacts.xml', '2018-02-24 12:56:31', '2018-05-07 10:22:14', 1, '1525659731946.jpg', '贝多芬的忧伤');
INSERT INTO `tb_song` VALUES (2, '时间煮雨简版', '王毅', '王毅', '2018-02-26 12:34:33', 5, '1519619671383.xml', 'artifacts.xml', '2018-02-26 12:34:33', '2018-05-07 10:21:30', 1, '1525659687842.jpg', '时间煮雨简版');
INSERT INTO `tb_song` VALUES (3, '广东爱情故事', '王毅', '王毅', '2018-02-26 12:35:12', 2, '1519619709684.xml', 'artifacts.xml', '2018-02-26 12:35:12', '2018-05-07 10:20:56', 1, '1525659652134.jpg', '广东爱情故事');
INSERT INTO `tb_song` VALUES (4, '菊次郎的夏天', '王毅', '王毅', '2018-02-26 12:37:57', 4, '1519619874300.xml', 'artifacts.xml', '2018-02-26 12:37:57', '2018-05-07 10:20:23', 1, '1525659621407.jpg', '菊次郎的夏天');
INSERT INTO `tb_song` VALUES (5, '站在最高点', '王毅', '王毅', '2018-02-26 12:38:31', 3, '1519619909089.xml', 'artifacts.xml', '2018-02-26 12:38:31', '2018-05-07 10:19:34', 1, '1525659571832.jpg', '站在最高点');
INSERT INTO `tb_song` VALUES (6, '夜的钢琴曲', '王毅', '王毅', '2018-02-26 12:42:02', 2, '1519620119672.xml', 'artifacts.xml', '2018-02-26 12:42:02', '2018-05-07 10:18:05', 0, '1525659482740.jpg', '夜的钢琴曲');
INSERT INTO `tb_song` VALUES (7, '梦中的婚礼', '王毅', '王毅', '2018-02-26 12:47:18', 2, '1523254225667.xml', '1 _1_.xml', '2018-02-26 12:47:18', '2018-05-07 10:17:06', 2, '1525659424125.jpg', '梦中的婚礼');
COMMIT;

-- ----------------------------
-- Table structure for tb_song_collect
-- ----------------------------
DROP TABLE IF EXISTS `tb_song_collect`;
CREATE TABLE `tb_song_collect` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `song_id` bigint(20) NOT NULL COMMENT '曲谱id',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_song_collect
-- ----------------------------
BEGIN;
INSERT INTO `tb_song_collect` VALUES (2, 4, 1, '2018-03-20 11:02:23');
INSERT INTO `tb_song_collect` VALUES (8, 11, 3, '2018-05-03 09:16:12');
INSERT INTO `tb_song_collect` VALUES (14, 18, 5, '2018-05-06 04:16:47');
COMMIT;

-- ----------------------------
-- Table structure for tb_song_history
-- ----------------------------
DROP TABLE IF EXISTS `tb_song_history`;
CREATE TABLE `tb_song_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `teach_id` int(11) NOT NULL COMMENT '教程id',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tb_song_new
-- ----------------------------
DROP TABLE IF EXISTS `tb_song_new`;
CREATE TABLE `tb_song_new` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `song_id` int(11) NOT NULL COMMENT '曲谱id',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_song_new
-- ----------------------------
BEGIN;
INSERT INTO `tb_song_new` VALUES (3, 1, 7, '2018-04-09 14:32:35');
INSERT INTO `tb_song_new` VALUES (4, 2, 6, '2018-04-09 14:32:35');
INSERT INTO `tb_song_new` VALUES (7, 3, 4, '2018-04-09 14:32:35');
INSERT INTO `tb_song_new` VALUES (9, 4, 5, '2018-04-09 14:32:35');
COMMIT;

-- ----------------------------
-- Table structure for tb_song_recommend
-- ----------------------------
DROP TABLE IF EXISTS `tb_song_recommend`;
CREATE TABLE `tb_song_recommend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `song_id` bigint(20) NOT NULL COMMENT '曲谱id',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_song_recommend
-- ----------------------------
BEGIN;
INSERT INTO `tb_song_recommend` VALUES (44, 6, 2, '2018-04-09 14:31:42');
INSERT INTO `tb_song_recommend` VALUES (47, 7, 3, '2018-04-09 14:31:42');
COMMIT;

-- ----------------------------
-- Table structure for tb_songset
-- ----------------------------
DROP TABLE IF EXISTS `tb_songset`;
CREATE TABLE `tb_songset` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `introduce` varchar(200) NOT NULL COMMENT '简介',
  `upload_user` varchar(50) NOT NULL COMMENT '上传者姓名',
  `release_time` datetime NOT NULL COMMENT '上架时间',
  `img` varchar(100) NOT NULL COMMENT '图片',
  `hard` int(2) NOT NULL COMMENT '难度',
  `style` int(2) NOT NULL COMMENT '风格',
  `person` int(2) NOT NULL COMMENT '人群',
  `scene` int(2) NOT NULL COMMENT '场景',
  `teaching` int(2) NOT NULL COMMENT '教材',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `subhead` varchar(50) NOT NULL,
  `author` varchar(50) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_songset
-- ----------------------------
BEGIN;
INSERT INTO `tb_songset` VALUES (1, '陈奕迅', '儿童钢琴', '王毅', '2018-02-24 15:26:19', '1525583660319.jpg', 1, 1, 0, 1, 1, '2018-02-24 15:26:19', '2018-05-06 13:14:24', '陈奕迅', '陈奕迅');
INSERT INTO `tb_songset` VALUES (2, '周杰伦', '周杰伦（Jay Chou），1979年1月18日出生于台湾省新北市，中国台湾流行乐男歌手、音乐人、演员、导演、编剧、监制、商人。', '王毅', '2018-02-26 14:39:44', '1525583412176.jpg', 4, 1, 0, 0, 1, '2018-02-26 14:39:44', '2018-05-06 13:10:20', '周杰伦', '周杰伦');
INSERT INTO `tb_songset` VALUES (3, '易烊千玺', '易烊千玺是什么人谁也不知道', 'sz', '2018-03-27 12:55:04', '1525583684109.jpg', 2, 2, 1, 0, 1, '2018-03-27 12:55:04', '2018-05-06 13:14:49', '易烊千玺', '易烊千玺');
INSERT INTO `tb_songset` VALUES (4, '刘德华', '这是一个老明星了', '432432', '2018-03-27 13:14:52', '1525583702479.jpg', 4, 2, 0, 1, 1, '2018-03-27 13:14:52', '2018-05-06 13:15:21', '刘德华', '刘德华');
INSERT INTO `tb_songset` VALUES (15, '周华健', '对 我就是周华健', '周杰伦', '2018-04-09 14:25:40', '1525583777974.jpg', 1, 1, 0, 0, 0, '2018-04-09 14:25:40', '2018-05-06 13:16:22', '周华健', '周华健');
INSERT INTO `tb_songset` VALUES (16, '麦当娜', '老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来了老外也来1', '杰克逊', '2018-04-09 14:27:17', '1525583745053.jpg', 0, 0, 0, 0, 0, '2018-04-09 14:27:17', '2018-05-06 19:20:21', '毛当了', '麦当劳');
COMMIT;

-- ----------------------------
-- Table structure for tb_songset_collect
-- ----------------------------
DROP TABLE IF EXISTS `tb_songset_collect`;
CREATE TABLE `tb_songset_collect` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `songset_id` bigint(20) NOT NULL COMMENT '曲集id',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_songset_collect
-- ----------------------------
BEGIN;
INSERT INTO `tb_songset_collect` VALUES (43, 6, 6, '2018-03-27 18:27:48');
INSERT INTO `tb_songset_collect` VALUES (44, 6, 7, '2018-03-29 14:49:01');
INSERT INTO `tb_songset_collect` VALUES (53, 10, 4, '2018-04-10 16:45:09');
INSERT INTO `tb_songset_collect` VALUES (54, 8, 1, '2018-04-28 10:08:50');
INSERT INTO `tb_songset_collect` VALUES (57, 16, 1, '2018-04-28 23:24:16');
INSERT INTO `tb_songset_collect` VALUES (61, 18, 2, '2018-05-06 04:16:59');
COMMIT;

-- ----------------------------
-- Table structure for tb_songset_new
-- ----------------------------
DROP TABLE IF EXISTS `tb_songset_new`;
CREATE TABLE `tb_songset_new` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `songset_id` int(11) NOT NULL COMMENT '曲集id',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_songset_new
-- ----------------------------
BEGIN;
INSERT INTO `tb_songset_new` VALUES (2, 2, 1, '2018-02-28 14:58:07');
COMMIT;

-- ----------------------------
-- Table structure for tb_songset_recommend
-- ----------------------------
DROP TABLE IF EXISTS `tb_songset_recommend`;
CREATE TABLE `tb_songset_recommend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `songset_id` bigint(20) NOT NULL COMMENT '曲集id',
  `sort` int(10) DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_songset_recommend
-- ----------------------------
BEGIN;
INSERT INTO `tb_songset_recommend` VALUES (10, 2, 1, '2018-04-09 14:28:47');
INSERT INTO `tb_songset_recommend` VALUES (13, 4, 4, '2018-04-09 14:28:47');
INSERT INTO `tb_songset_recommend` VALUES (14, 16, 5, '2018-04-09 14:28:47');
COMMIT;

-- ----------------------------
-- Table structure for tb_songset_song
-- ----------------------------
DROP TABLE IF EXISTS `tb_songset_song`;
CREATE TABLE `tb_songset_song` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `songset_id` bigint(20) NOT NULL COMMENT '曲集id',
  `song_id` bigint(20) NOT NULL COMMENT '曲谱id',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_songset_song
-- ----------------------------
BEGIN;
INSERT INTO `tb_songset_song` VALUES (27, 15, 7, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (28, 15, 6, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (29, 15, 5, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (30, 15, 4, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (31, 15, 3, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (32, 15, 2, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (33, 15, 1, '2018-04-09 14:25:40');
INSERT INTO `tb_songset_song` VALUES (34, 4, 7, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (35, 4, 6, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (36, 4, 5, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (37, 4, 4, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (38, 4, 3, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (39, 4, 2, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (40, 4, 1, '2018-04-09 14:25:50');
INSERT INTO `tb_songset_song` VALUES (41, 3, 7, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (42, 3, 6, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (43, 3, 5, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (44, 3, 4, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (45, 3, 3, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (46, 3, 2, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (47, 3, 1, '2018-04-09 14:26:00');
INSERT INTO `tb_songset_song` VALUES (48, 2, 7, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (49, 2, 6, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (50, 2, 5, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (51, 2, 4, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (52, 2, 3, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (53, 2, 2, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (54, 2, 1, '2018-04-09 14:26:21');
INSERT INTO `tb_songset_song` VALUES (55, 1, 7, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (56, 1, 6, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (57, 1, 5, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (58, 1, 4, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (59, 1, 3, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (60, 1, 2, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (61, 1, 1, '2018-04-09 14:26:32');
INSERT INTO `tb_songset_song` VALUES (69, 16, 1, '2018-05-06 19:20:19');
COMMIT;

-- ----------------------------
-- Table structure for tb_teach
-- ----------------------------
DROP TABLE IF EXISTS `tb_teach`;
CREATE TABLE `tb_teach` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `subhead` varchar(50) NOT NULL,
  `introduce` varchar(100) NOT NULL COMMENT '简介',
  `img` varchar(100) NOT NULL COMMENT '图片',
  `type` int(2) NOT NULL COMMENT '类型',
  `author` varchar(50) NOT NULL COMMENT '作者',
  `upload_user` varchar(50) NOT NULL COMMENT '上传者姓名',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_teach
-- ----------------------------
BEGIN;
INSERT INTO `tb_teach` VALUES (1, '陈小春', '陈小春', '简介', '1523256898538.jpg', 2, '佚名', '佚名', '2018-02-28 16:18:16', '2018-04-09 14:55:36');
INSERT INTO `tb_teach` VALUES (2, '梅艳芳', '梅艳芳', '简介', '1523256865129.jpg', 2, '佚名', '佚名', '2018-02-28 16:58:45', '2018-04-09 14:54:34');
INSERT INTO `tb_teach` VALUES (3, '刘德华', '刘德华', '简介', '1523256846801.jpg', 2, '佚名', '王毅', '2018-02-28 17:03:42', '2018-04-09 14:54:11');
INSERT INTO `tb_teach` VALUES (4, '王力宏', '王力宏', '简介', '1522718943279.png', 1, '佚名', '佚名', '2018-02-28 17:48:32', '2018-04-09 14:53:49');
INSERT INTO `tb_teach` VALUES (5, '周杰伦', '周杰伦', '简介', '1523256771559.jpg', 1, '佚名', '佚名', '2018-02-28 17:49:00', '2018-04-09 14:53:38');
INSERT INTO `tb_teach` VALUES (6, '范特西', '范特西', '简介', '1523256731104.jpg', 1, '佚名', '佚名', '2018-02-28 17:58:15', '2018-04-09 14:53:07');
INSERT INTO `tb_teach` VALUES (7, '车尔尼', '车尔尼', '简介', '1523256658477.jpg', 0, '佚名', '佚名', '2018-02-28 18:00:43', '2018-04-28 14:17:18');
INSERT INTO `tb_teach` VALUES (8, '拜厄', '拜厄', '简介', '1523256617763.jpg', 0, '佚名', '佚名', '2018-02-28 18:02:29', '2018-05-07 13:59:01');
INSERT INTO `tb_teach` VALUES (10, '哈农', '哈农', '哈农简介', '1523256418579.jpg', 0, '佚名', '佚名', '2018-04-09 14:06:18', '2018-05-07 13:58:54');
COMMIT;

-- ----------------------------
-- Table structure for tb_teach_collect
-- ----------------------------
DROP TABLE IF EXISTS `tb_teach_collect`;
CREATE TABLE `tb_teach_collect` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `teach_id` bigint(20) NOT NULL COMMENT '教程id',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_teach_collect
-- ----------------------------
BEGIN;
INSERT INTO `tb_teach_collect` VALUES (1, 4, 1, '2018-03-20 10:40:38');
INSERT INTO `tb_teach_collect` VALUES (29, 6, 7, '2018-04-12 22:19:51');
INSERT INTO `tb_teach_collect` VALUES (30, 6, 4, '2018-04-13 10:57:47');
INSERT INTO `tb_teach_collect` VALUES (32, 6, 10, '2018-04-27 13:40:41');
INSERT INTO `tb_teach_collect` VALUES (34, 16, 7, '2018-04-28 21:51:46');
INSERT INTO `tb_teach_collect` VALUES (35, 16, 1, '2018-04-28 23:19:43');
INSERT INTO `tb_teach_collect` VALUES (36, 6, 1, '2018-04-30 18:00:42');
INSERT INTO `tb_teach_collect` VALUES (39, 17, 7, '2018-05-03 21:07:47');
INSERT INTO `tb_teach_collect` VALUES (40, 17, 8, '2018-05-03 21:07:52');
INSERT INTO `tb_teach_collect` VALUES (41, 17, 1, '2018-05-03 22:30:28');
INSERT INTO `tb_teach_collect` VALUES (42, 17, 15, '2018-05-03 22:30:34');
INSERT INTO `tb_teach_collect` VALUES (43, 17, 15, '2018-05-03 22:31:12');
INSERT INTO `tb_teach_collect` VALUES (44, 17, 2, '2018-05-03 22:31:34');
INSERT INTO `tb_teach_collect` VALUES (45, 18, 1, '2018-05-06 04:17:10');
INSERT INTO `tb_teach_collect` VALUES (46, 17, 10, '2018-05-06 21:13:14');
COMMIT;

-- ----------------------------
-- Table structure for tb_teach_song
-- ----------------------------
DROP TABLE IF EXISTS `tb_teach_song`;
CREATE TABLE `tb_teach_song` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `teach_id` bigint(20) NOT NULL COMMENT '教程id',
  `song_id` bigint(20) NOT NULL COMMENT '曲谱id',
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_teach_song
-- ----------------------------
BEGIN;
INSERT INTO `tb_teach_song` VALUES (1, 1, 7, '2018-02-28 16:58:08');
INSERT INTO `tb_teach_song` VALUES (2, 1, 4, '2018-02-28 16:58:08');
INSERT INTO `tb_teach_song` VALUES (3, 3, 1, '2018-02-28 17:03:42');
INSERT INTO `tb_teach_song` VALUES (4, 3, 2, '2018-02-28 17:03:42');
INSERT INTO `tb_teach_song` VALUES (5, 4, 5, '2018-02-28 17:48:32');
INSERT INTO `tb_teach_song` VALUES (6, 4, 3, '2018-02-28 17:48:32');
INSERT INTO `tb_teach_song` VALUES (7, 5, 2, '2018-02-28 17:49:01');
INSERT INTO `tb_teach_song` VALUES (8, 5, 3, '2018-02-28 17:49:01');
INSERT INTO `tb_teach_song` VALUES (9, 6, 2, '2018-02-28 17:58:15');
INSERT INTO `tb_teach_song` VALUES (10, 6, 3, '2018-02-28 17:58:15');
INSERT INTO `tb_teach_song` VALUES (11, 7, 5, '2018-02-28 18:00:43');
INSERT INTO `tb_teach_song` VALUES (12, 7, 6, '2018-02-28 18:00:43');
INSERT INTO `tb_teach_song` VALUES (13, 8, 1, '2018-02-28 18:02:29');
INSERT INTO `tb_teach_song` VALUES (14, 8, 3, '2018-02-28 18:02:29');
INSERT INTO `tb_teach_song` VALUES (15, 2, 2, '2018-03-23 23:07:18');
INSERT INTO `tb_teach_song` VALUES (16, 2, 1, '2018-03-23 23:07:18');
INSERT INTO `tb_teach_song` VALUES (17, 9, 7, '2018-04-09 14:00:57');
INSERT INTO `tb_teach_song` VALUES (18, 9, 6, '2018-04-09 14:00:57');
INSERT INTO `tb_teach_song` VALUES (21, 10, 7, '2018-04-09 14:43:15');
INSERT INTO `tb_teach_song` VALUES (22, 10, 6, '2018-04-09 14:43:15');
INSERT INTO `tb_teach_song` VALUES (23, 10, 5, '2018-04-09 14:43:15');
INSERT INTO `tb_teach_song` VALUES (24, 10, 4, '2018-04-09 14:43:15');
INSERT INTO `tb_teach_song` VALUES (25, 10, 3, '2018-04-09 14:43:15');
INSERT INTO `tb_teach_song` VALUES (26, 10, 2, '2018-04-09 14:43:15');
INSERT INTO `tb_teach_song` VALUES (27, 10, 1, '2018-04-09 14:43:15');
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `img` varchar(100) DEFAULT NULL,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `sex` int(2) DEFAULT NULL COMMENT '性别',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, NULL, 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', 0, '2017-03-23 22:37:41');
INSERT INTO `tb_user` VALUES (2, NULL, '1', '1', 'ef2d127de37b942baad06145e54b0c619a1f22327b2ebbcfbec78f5564afe39d', NULL, '2018-03-15 11:15:54');
INSERT INTO `tb_user` VALUES (4, NULL, '323', '2', 'd4735e3a265e16eee03f59718b9b5d03019c07d8b6c51f90da3a666eec13ab35', 0, '2018-03-15 12:17:57');
INSERT INTO `tb_user` VALUES (5, NULL, '32', '32', '98f1f17f9a73ccfe3e25940add8d9ce9bf05513104cacb84f2f1185bf5886a84', NULL, '2018-03-21 21:00:15');
INSERT INTO `tb_user` VALUES (6, '1522692017542.file', '菩提', '15950450693', '5fae31539e070a690c1b63720c25eb5b86084b5098a942c86c89c1d67157ed6b', 1, '2018-03-22 14:09:16');
INSERT INTO `tb_user` VALUES (7, NULL, '18168896116', '18168896116', 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', NULL, '2018-03-22 15:17:44');
INSERT INTO `tb_user` VALUES (8, NULL, '13506171167', '13506171167', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', NULL, '2018-03-26 14:08:20');
INSERT INTO `tb_user` VALUES (9, NULL, '17751528219', '17751528219', 'ee79976c9380d5e337fc1c095ece8c8f22f91f306ceeb161fa51fecede2c4ba1', 0, '2018-03-31 21:12:16');
INSERT INTO `tb_user` VALUES (10, '1523346049564.file', '18118895586', '18118895586', '3f77e0cf2839e806ffe7ef995acf2d1f9490f795a384097d8c89022bfd8ab5ec', 1, '2018-04-03 09:02:27');
INSERT INTO `tb_user` VALUES (11, 'http://tf.ioniclub.com/sys/file/getImg?path=1525309858496.file', '葡萄', '13357720188', '4812a2f8dd0895cdf1cc928367512b92515183d785cf332ddfb81a823e2a3a94', 0, '2018-04-03 14:15:46');
INSERT INTO `tb_user` VALUES (12, NULL, '18511831914', '18511831914', '3b4e266a89805c9d020f9aca6638ad63e8701fc8c75c0ca1952d14054d1f10cf', NULL, '2018-04-04 10:58:15');
INSERT INTO `tb_user` VALUES (13, NULL, '15011001663', '15011001663', 'f01d6cd5969daeba67e906dfe3bb9e74d39813ef7f6f6be534f82c32eafaeafd', NULL, '2018-04-05 13:47:16');
INSERT INTO `tb_user` VALUES (14, NULL, '15715153640', '15715153640', '9626c7444717aab7a3bbdd509bcafa35a7491e9478d421b38e539a621f695edd', NULL, '2018-04-11 17:12:09');
INSERT INTO `tb_user` VALUES (15, NULL, '13372508323', '13372508323', '585d5996cdb1083ba8f820edd8ecfcb49969164573e49a1db5584e2c93820532', NULL, '2018-04-27 09:55:03');
INSERT INTO `tb_user` VALUES (16, 'http://tf.ioniclub.com/sys/file/getImg?path=1524928763040.file', 'Love you99', '18613155485', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1, '2018-04-27 22:46:31');
INSERT INTO `tb_user` VALUES (17, NULL, 'Chico', '18516276648', '8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92', 1, '2018-04-27 23:03:14');
INSERT INTO `tb_user` VALUES (18, 'http://tf.ioniclub.com/sys/file/getImg?path=1525551969163.file', '忧郁的眼神', '13815898825', 'ee79976c9380d5e337fc1c095ece8c8f22f91f306ceeb161fa51fecede2c4ba1', 0, '2018-05-05 03:43:58');
COMMIT;

-- ----------------------------
-- Table structure for tb_vedio
-- ----------------------------
DROP TABLE IF EXISTS `tb_vedio`;
CREATE TABLE `tb_vedio` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `teach_id` bigint(20) NOT NULL COMMENT '教程id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `url` varchar(100) NOT NULL COMMENT '地址',
  `create_time` datetime DEFAULT NULL,
  `introduce` varchar(200) DEFAULT NULL COMMENT '介绍',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_vedio
-- ----------------------------
BEGIN;
INSERT INTO `tb_vedio` VALUES (73, 6, '示范', '12', '2018-04-09 14:53:07', NULL);
INSERT INTO `tb_vedio` VALUES (79, 7, '车尔尼', '45', '2018-04-28 14:17:18', 'null');
INSERT INTO `tb_vedio` VALUES (80, 10, '视频名', 'http://www.yy6042.org/play/19484-0-0.html', '2018-05-07 13:58:54', '');
INSERT INTO `tb_vedio` VALUES (81, 8, '视频名', '213', '2018-05-07 13:59:01', '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
